翻訳と辞書 Words near each other ・ Information Research ・ Information Research Department ・ Information resource ・ Information Resources Management College ・ Information retrieval ・ Information retrieval applications ・ Information Retrieval Facility ・ Information retrieval query language ・ Information Retrieval Specialist Group ・ Information Retrieved ・ Information Retrieved Pt. B ・ Information Retrieved, Pt. A ・ Information revolution ・ Information rights management ・ Information Rules ・ Information schema ・ Information school ・ Information science ・ Information Sciences and Technology Building ・ Information Sciences Institute ・ Information scientist ・ Information search process ・ Information security ・ Information security audit ・ Information Security Automation Program ・ Information Security Awareness ・ Information Security Awareness Forum ・ Information Security Department ・ Information Security Engineering Certified Professional ・ Information Security Forum Dictionary Lists mini英和辞書 mini和英辞書 Webster 1913 Latin-English FOLDOC Wikipedia English ウィキペディア

翻訳と辞書　辞書検索 [ 開発暫定版 ] スポンサード リンク Information schema ： ウィキペディア英語版 Information schema In relational databases, the information schema (information_schema) is an ANSI-standard set of read-only views which provide information about all of the tables, views, columns, and procedures in a database.〔 〕 It can be used as a source of the information which some databases make available through non-standard commands, such as: * the SHOW command of MySQL * the DESCRIBE command of Oracle's SQL *Plus * the \d command in psql (PostgreSQL's default command-line program). => SELECT count(table_name) FROM information_schema.tables; count ------- 99 (1 row) => SELECT column_name, data_type, column_default, is_nullable FROM information_schema.columns WHERE table_name='alpha'; column_name | data_type | column_default | is_nullable -------------+-----------+----------------+------------- foo | integer | | YES bar | character | | YES (2 rows) => SELECT * FROM information_schema.information_schema_catalog_name; catalog_name -------------- johnd (1 row) == Implementation == As a notable exception among major database systems, Oracle does not implement the information schema. An (open-source project ) exists to address this. RDBMSs which support information_schema include: * Microsoft SQL Server * MySQL * PostgreSQL * InterSystems Caché RDBMSs which do not support information_schema include: * Oracle Database * IBM DB2 * SQLite 抄文引用元・出典: フリー百科事典『 ウィキペディア（Wikipedia）』 ■ウィキペディアで「Information schema」の詳細全文を読む スポンサード リンク 翻訳と辞書 : 翻訳のためのインターネットリソース Copyright(C) kotoba.ne.jp 1997-2016. All Rights Reserved.